Data Tables and Pivot Tables: Essential Excel Skills for Business (Essential Excel Business for Skills Book 2) by Carl Nixon

Author:Carl Nixon [Nixon, Carl]
Language: eng
Format: epub
Published: 2017-01-24T08:00:00+00:00

When we have made our selections our Pivot Table updates to show;

Fig 11-9 – Our refined Pivot Table selections in action.

As a result of our choices, our Pivot Table now only shows chair sales for the Bristol store.

Stage 4 – Getting Even More Information from Our Pivot Table.

Automatically summing up data is a great time saver, but sometimes we need to know other information such as number of sales or average sales values. Pivot tables have you covered there as well.

If you haven’t already, set your Store field to All and your Product Group field to All. Then follow these steps.

Select one of the Total Sales values in your Pivot Table.

Right click on the cell and select Summarize Values By.

Select if you want to see a Count, the Average value, the Minimum value or the Maximum value. In our example, we are selecting count.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.